CREATE TABLE [dbo].[AtomPanel]
(
[AtomPanelKey] [uniqueidentifier] NOT NULL,
[ComponentKey] [uniqueidentifier] NOT NULL,
[AtomPanelName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AtomPanelStatusCode] [smallint] NOT NULL,
[AtomPanelTypeCode] [smallint] NOT NULL,
[AtomPanelPurposeCode] [smallint] NOT NULL,
[AtomPanelFactoryStateCode] [smallint] NOT NULL,
[DefaultForPurposeFlag] [bit] NOT NULL CONSTRAINT [DF_AtomPanel_DefaultForPurposeFlag] DEFAULT ((0)),
[AtomPanelDescription] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AtomPanelDesign] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[AtomPanel] ADD CONSTRAINT [PK_AtomPanel] PRIMARY KEY CLUSTERED ([AtomPanelKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AtomPanel] ADD CONSTRAINT [AK_AtomPanel_AtomPanelName] UNIQUE NONCLUSTERED ([AtomPanelName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AtomPanel_AtomPanelFactoryStateCode] ON [dbo].[AtomPanel] ([AtomPanelFactoryStateCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AtomPanel_AtomPanelPurposeCode] ON [dbo].[AtomPanel] ([AtomPanelPurposeCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AtomPanel_AtomPanelStatusCode] ON [dbo].[AtomPanel] ([AtomPanelStatusCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AtomPanel_AtomPanelTypeCode] ON [dbo].[AtomPanel] ([AtomPanelTypeCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AtomPanel_ComponentKey] ON [dbo].[AtomPanel] ([ComponentKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AtomPanel_UpdatedByUserKey] ON [dbo].[AtomPanel] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AtomPanel] ADD CONSTRAINT [FK_AtomPanel_AtomPanelFactoryStateRef] FOREIGN KEY ([AtomPanelFactoryStateCode]) REFERENCES [dbo].[AtomPanelFactoryStateRef] ([AtomPanelFactoryStateCode])
GO
ALTER TABLE [dbo].[AtomPanel] ADD CONSTRAINT [FK_AtomPanel_AtomPanelPurposeRef] FOREIGN KEY ([AtomPanelPurposeCode]) REFERENCES [dbo].[AtomPanelPurposeRef] ([AtomPanelPurposeCode])
GO
ALTER TABLE [dbo].[AtomPanel] ADD CONSTRAINT [FK_AtomPanel_AtomPanelStatusRef] FOREIGN KEY ([AtomPanelStatusCode]) REFERENCES [dbo].[AtomPanelStatusRef] ([AtomPanelStatusCode])
GO
ALTER TABLE [dbo].[AtomPanel] ADD CONSTRAINT [FK_AtomPanel_AtomPanelTypeRef] FOREIGN KEY ([AtomPanelTypeCode]) REFERENCES [dbo].[AtomPanelTypeRef] ([AtomPanelTypeCode])
GO
ALTER TABLE [dbo].[AtomPanel] ADD CONSTRAINT [FK_AtomPanel_ComponentRegistry] FOREIGN KEY ([ComponentKey]) REFERENCES [dbo].[ComponentRegistry] ([ComponentKey])
GO
ALTER TABLE [dbo].[AtomPanel] ADD CONSTRAINT [FK_AtomPanel_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO